Utilities 313!¶

Of note, the switch between CleanChoice and Pepco. It makes Feb 2021 unusually low, and June 2023 unusually high.

Also, the last month will probably be off. Not completely billed yet.

Out[2]:
'\n(with code cells:)\njupyter nbconvert --to html --execute utilities_313_EDA.ipynb\n\n(without code cells:)\njupyter nbconvert --to html --execute --TemplateExporter.exclude_input=True utilities_313_EDA.ipynb\n'
Out[4]:
Amount Year Month
count 236.000000 236.000000 236.000000
mean 86.538771 2022.449153 6.453390
std 68.181854 1.278945 3.581565
min 0.000000 2020.000000 1.000000
25% 18.000000 2021.000000 3.000000
50% 79.990000 2022.000000 6.000000
75% 137.022500 2023.250000 10.000000
max 370.090000 2025.000000 12.000000

Note the Pepco / CleanChoice data. After this, they'll be consolidated into "Electric"

Out[16]:
Amount Amount_per_person
count 53.000000 53.000000
mean 385.342453 128.447484
std 88.659247 29.553082
min 192.990000 64.330000
25% 335.200000 111.733333
50% 387.540000 129.180000
75% 420.660000 140.220000
max 628.080000 209.360000
<Figure size 1000x600 with 0 Axes>